Software

Ask something
Discussion Locked

Importing data into spreadsheet/database

0 helpful
5 replies

by meiselesesq

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a way to import text data into a database and/or speadsheet?

Details:information in website set forth in columns, I assume from their database. I can save the info to my computer as a text file but would like to import the data into a database or spreadsheet.

5 replies

by thechas

If you can copy the data as text, then, the "Parse" command should do the job.

So long as the data is evenly spaced from row to row, or has a comma or other 'common' separator.

The Parse command looks at the first row of data, and creates a parsing algorithm.
As long as ALL rows of data follow the same format and spacing, the parse command does a fairly good job.

The Parse command works best if the data is pure ASCII text.

I don't know of any other way aside from copy and paste to easily capture the data from a web page into a spreadsheet.

Chas

This discussion is closed to new replies.