Hello,
I am preparing an excel file for the Ticket Import Utility, and the first 5 columns in the spreadsheet are to be left blank as we don't have any data to input in them. According to the documentation, they have to be present even though there isn't any data for them. I am running into the issue that when the file is saved it deletes those first blank 5 columns. There is no header so it just thinks its blank data. The rest of the blank columns in the spreadsheet are fine, its just the ones at the beginning before the data in the columns begins.
Has anyone ran into this before and might you have a solution to keep the blank columns?
Thanks!
Hi Amy,
Try this: when you save the export file, include the column headers. Then before you upload the file, edit it in Notepad (or Notepad++, a very handy free utility you can download, and which is much more versatile) and remove the header line. That should preserve those columns.
Alternatively, do a variation on that theme and put some dummy data in the first row of data for those five columns, save the file, edit it and remove the dummy data. Again, that should preserve the existence of the columns.