Is there a fast an easy way to import a large spreadsheet?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a doc with 365 columns and 4 rows.  Two of which contain formulas.  I want a table inside of my app to to contain this information (It is the historical, median, and trend).  But, when I am importing it as a .csv from dropbox, it is having me import each column as an individual field.  Thats 365 fields.  Granted in the amount of time that I have spent looking for an answer, I could have clicked all 365 lol, but I am going to have to do this another 20 times.  

I assume there is a better way that I just haven't realized since I am new to QB.

Thank you!
Photo of Gretta

Gretta

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
It appears to  me that you want to import your spreadsheet which is organized as 4 rows by 365 columns into a table organized as as four fields. The easiest way to do this is to transpose the data in Excel prior to importing. See:

Switch (transpose) columns and rows
https://support.office.com/en-us/article/Switch-transpose-columns-and-rows-ed1215f5-59af-47e6-953b-0...