Troubleshooting Import big excel file

I have this excel file, I'm trying to import it but I cannot. The cursor keeps spinning all the time.

Can you help me point out what's wrong with the file or the way I import it?

Thank you so much.

[Bob Thompson]

How big is the file?

Answer 1

[dpb]

>> t=readtable('export.csv');
>> whos t
  Name       Size              Bytes  Class    Attributes

  t         45x255            270679  table              

>> t(1:10,1:10)
ans =
  10×10 table
    ID       event_name        date_contacts    name    phone1    phone1_type    phone1_msg    phone2    phone2_type    phone2_msg
    __    _________________    _____________    ____    ______    ___________    __________    ______    ___________    __________
    1     'baseline1_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    1     'baseline2_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    1     'baseline3_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    1     'baseline4_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    1     'baseline5_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    1     'baseline6_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    2     'baseline1_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    2     'baseline2_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    2     'baseline3_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
    2     'baseline4_arm_1'    NaN              ''      ''        NaN            NaN           ''        NaN            NaN       
>> 

Didn't seem to have any trouble here.

The files isn't all that big...it's mostly empty fields.

>> d=dir('export.csv')
d = 
  struct with fields:

       name: 'export.csv'
     folder: 'C:\Users\Duane\Documents\MATLAB\Work'
       date: '13-Aug-2019 14:47:19'
      bytes: 17449
      isdir: 0
    datenum: 7.3765e+05
>>

It's only 17k on disk...

[Ted Dang]

Heyyyyyy I'm glad to see you here again.

the first step I took: hit the "Import Data" Button and the cursor has been spinning since then. I don't know if I've imported it right...?

[dpb]

Dunno...I've never tried using the fancy doodads...I just write code. No idea what it's trying to do.